home *** CD-ROM | disk | FTP | other *** search
/ Developer Source 7 / developer source - volume 7.iso / dbmsa / may96 / kimbf102.gif < prev    next >
Graphics Interchange Format  |  1996-11-15  |  43KB  |  343x328  |  4-bit (16 colors)
Labels: text | screenshot | font
OCR: Customer dimension join to large purchases fact table customer key name address city, state birth date Demographics dimension join to large purchases fact table demographics key Income band purchases band humber children education level Figure 2. To track the changing demographic values, the Customer dimension is split into two dimensions. The "hot" values are first banded into discrete values, and then are presented as a separate Demographics dimension. This dimension requires the creation of a new artificial key.